How to display the day of the week in Excel
Excel offers a plethora of valuable functions. In this article, we will discuss how to dispaly the day of the week in Excel when given a date. For instance, if the date is 8/01/2023, the output should be Tuesday.
New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.
The Text function is utilized to display the day of the week in Excel.
The Text function in Excel
The Text function is employed to alter the formatting of a number by applying format codes.
Syntax:
=TEXT(Value, format_Text)
As dates in Excel are stored as numbers, the Text function can be applied to dates to format them and display the corresponding day of the week.
Steps to display the day of the week in Excel
To illustrate this, I will utilize a sample dataset (provided below). It contains dates in the month of August. Additionally, there is an empty column designated for the Day of the Week, wherein we will apply our formula.
In the cell B2, I will write a formula:
=TEXT(A2,”dddd”)
In Cell A2, you will find the Date value. Utilizing the “dddd” format will provide us with the day of the week. I will then use the autofill feature to populate the remaning cells in column B, generating values for all the dates. The resulting output will be displayed as follows:
To obtain the abbreviated day of the week, utilize “ddd” instead.
Explore more insights like these and deepen your Excel proficiency with comprehensive knowledge from the book Excel Basics to Advanced.
Enhance your Excel skills by exploring MSExcel Blogs for more valuable tips.
New to Excel? Want to see Excel in action? Watch the full Excel for Beginners Playlist here:
